class CreatePairsPlayers < ActiveRecord::Migration
  def self.up
    create_table :pairs_players, :primary_key=>"pair_player_id" do |t|
      t.column :pair_id, :integer
      t.column :player_id, :integer
    end
#    execute "
#      ALTER TABLE pairs_players ADD FOREIGN KEY (pair_id) REFERENCES pairs (pair_id);
#      ALTER TABLE pairs_players ADD FOREIGN KEY (player_id) REFERENCES players (player_id);
#    "
  end

  def self.down
    drop_table :pairs_players
  end
end
